package com.yunjian.core.busi.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class HousePropertyInfoExample {
    /**
	 * @mbggenerated
	 */
	protected String orderByClause;
	/**
	 * @mbggenerated
	 */
	protected boolean distinct;
	/**
	 * @mbggenerated
	 */
	protected List<Criteria> oredCriteria;

	/**
	 * @mbggenerated
	 */
	public HousePropertyInfoExample() {
		oredCriteria = new ArrayList<Criteria>();
	}

	/**
	 * @mbggenerated
	 */
	public void setOrderByClause(String orderByClause) {
		this.orderByClause = orderByClause;
	}

	/**
	 * @mbggenerated
	 */
	public String getOrderByClause() {
		return orderByClause;
	}

	/**
	 * @mbggenerated
	 */
	public void setDistinct(boolean distinct) {
		this.distinct = distinct;
	}

	/**
	 * @mbggenerated
	 */
	public boolean isDistinct() {
		return distinct;
	}

	/**
	 * @mbggenerated
	 */
	public List<Criteria> getOredCriteria() {
		return oredCriteria;
	}

	/**
	 * @mbggenerated
	 */
	public void or(Criteria criteria) {
		oredCriteria.add(criteria);
	}

	/**
	 * @mbggenerated
	 */
	public Criteria or() {
		Criteria criteria = createCriteriaInternal();
		oredCriteria.add(criteria);
		return criteria;
	}

	/**
	 * @mbggenerated
	 */
	public Criteria createCriteria() {
		Criteria criteria = createCriteriaInternal();
		if (oredCriteria.size() == 0) {
			oredCriteria.add(criteria);
		}
		return criteria;
	}

	/**
	 * @mbggenerated
	 */
	protected Criteria createCriteriaInternal() {
		Criteria criteria = new Criteria();
		return criteria;
	}

	/**
	 * @mbggenerated
	 */
	public void clear() {
		oredCriteria.clear();
		orderByClause = null;
		distinct = false;
	}

	/**
	 * This class was generated by MyBatis Generator. This class corresponds to the database table house_property_info
	 * @mbggenerated
	 */
	protected abstract static class GeneratedCriteria {
		protected List<Criterion> criteria;

		protected GeneratedCriteria() {
			super();
			criteria = new ArrayList<Criterion>();
		}

		public boolean isValid() {
			return criteria.size() > 0;
		}

		public List<Criterion> getAllCriteria() {
			return criteria;
		}

		public List<Criterion> getCriteria() {
			return criteria;
		}

		protected void addCriterion(String condition) {
			if (condition == null) {
				throw new RuntimeException("Value for condition cannot be null");
			}
			criteria.add(new Criterion(condition));
		}

		protected void addCriterion(String condition, Object value,
				String property) {
			if (value == null) {
				throw new RuntimeException("Value for " + property
						+ " cannot be null");
			}
			criteria.add(new Criterion(condition, value));
		}

		protected void addCriterion(String condition, Object value1,
				Object value2, String property) {
			if (value1 == null || value2 == null) {
				throw new RuntimeException("Between values for " + property
						+ " cannot be null");
			}
			criteria.add(new Criterion(condition, value1, value2));
		}

		public Criteria andIdIsNull() {
			addCriterion("ID is null");
			return (Criteria) this;
		}

		public Criteria andIdIsNotNull() {
			addCriterion("ID is not null");
			return (Criteria) this;
		}

		public Criteria andIdEqualTo(String value) {
			addCriterion("ID =", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdNotEqualTo(String value) {
			addCriterion("ID <>", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdGreaterThan(String value) {
			addCriterion("ID >", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdGreaterThanOrEqualTo(String value) {
			addCriterion("ID >=", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdLessThan(String value) {
			addCriterion("ID <", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdLessThanOrEqualTo(String value) {
			addCriterion("ID <=", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdLike(String value) {
			addCriterion("ID like", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdNotLike(String value) {
			addCriterion("ID not like", value, "id");
			return (Criteria) this;
		}

		public Criteria andIdIn(List<String> values) {
			addCriterion("ID in", values, "id");
			return (Criteria) this;
		}

		public Criteria andIdNotIn(List<String> values) {
			addCriterion("ID not in", values, "id");
			return (Criteria) this;
		}

		public Criteria andIdBetween(String value1, String value2) {
			addCriterion("ID between", value1, value2, "id");
			return (Criteria) this;
		}

		public Criteria andIdNotBetween(String value1, String value2) {
			addCriterion("ID not between", value1, value2, "id");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoIsNull() {
			addCriterion("PROPERTY_CER_NO is null");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoIsNotNull() {
			addCriterion("PROPERTY_CER_NO is not null");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoEqualTo(String value) {
			addCriterion("PROPERTY_CER_NO =", value, "propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoNotEqualTo(String value) {
			addCriterion("PROPERTY_CER_NO <>", value, "propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoGreaterThan(String value) {
			addCriterion("PROPERTY_CER_NO >", value, "propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoGreaterThanOrEqualTo(String value) {
			addCriterion("PROPERTY_CER_NO >=", value, "propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoLessThan(String value) {
			addCriterion("PROPERTY_CER_NO <", value, "propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoLessThanOrEqualTo(String value) {
			addCriterion("PROPERTY_CER_NO <=", value, "propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoLike(String value) {
			addCriterion("PROPERTY_CER_NO like", value, "propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoNotLike(String value) {
			addCriterion("PROPERTY_CER_NO not like", value, "propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoIn(List<String> values) {
			addCriterion("PROPERTY_CER_NO in", values, "propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoNotIn(List<String> values) {
			addCriterion("PROPERTY_CER_NO not in", values, "propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoBetween(String value1, String value2) {
			addCriterion("PROPERTY_CER_NO between", value1, value2,
					"propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerNoNotBetween(String value1, String value2) {
			addCriterion("PROPERTY_CER_NO not between", value1, value2,
					"propertyCerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoIsNull() {
			addCriterion("REGISTER_NO is null");
			return (Criteria) this;
		}

		public Criteria andRegisterNoIsNotNull() {
			addCriterion("REGISTER_NO is not null");
			return (Criteria) this;
		}

		public Criteria andRegisterNoEqualTo(String value) {
			addCriterion("REGISTER_NO =", value, "registerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoNotEqualTo(String value) {
			addCriterion("REGISTER_NO <>", value, "registerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoGreaterThan(String value) {
			addCriterion("REGISTER_NO >", value, "registerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoGreaterThanOrEqualTo(String value) {
			addCriterion("REGISTER_NO >=", value, "registerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoLessThan(String value) {
			addCriterion("REGISTER_NO <", value, "registerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoLessThanOrEqualTo(String value) {
			addCriterion("REGISTER_NO <=", value, "registerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoLike(String value) {
			addCriterion("REGISTER_NO like", value, "registerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoNotLike(String value) {
			addCriterion("REGISTER_NO not like", value, "registerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoIn(List<String> values) {
			addCriterion("REGISTER_NO in", values, "registerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoNotIn(List<String> values) {
			addCriterion("REGISTER_NO not in", values, "registerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoBetween(String value1, String value2) {
			addCriterion("REGISTER_NO between", value1, value2, "registerNo");
			return (Criteria) this;
		}

		public Criteria andRegisterNoNotBetween(String value1, String value2) {
			addCriterion("REGISTER_NO not between", value1, value2,
					"registerNo");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearIsNull() {
			addCriterion("PROPERTY_CER_YEAR is null");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearIsNotNull() {
			addCriterion("PROPERTY_CER_YEAR is not null");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearEqualTo(String value) {
			addCriterion("PROPERTY_CER_YEAR =", value, "propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearNotEqualTo(String value) {
			addCriterion("PROPERTY_CER_YEAR <>", value, "propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearGreaterThan(String value) {
			addCriterion("PROPERTY_CER_YEAR >", value, "propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearGreaterThanOrEqualTo(String value) {
			addCriterion("PROPERTY_CER_YEAR >=", value, "propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearLessThan(String value) {
			addCriterion("PROPERTY_CER_YEAR <", value, "propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearLessThanOrEqualTo(String value) {
			addCriterion("PROPERTY_CER_YEAR <=", value, "propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearLike(String value) {
			addCriterion("PROPERTY_CER_YEAR like", value, "propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearNotLike(String value) {
			addCriterion("PROPERTY_CER_YEAR not like", value, "propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearIn(List<String> values) {
			addCriterion("PROPERTY_CER_YEAR in", values, "propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearNotIn(List<String> values) {
			addCriterion("PROPERTY_CER_YEAR not in", values, "propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearBetween(String value1, String value2) {
			addCriterion("PROPERTY_CER_YEAR between", value1, value2,
					"propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andPropertyCerYearNotBetween(String value1,
				String value2) {
			addCriterion("PROPERTY_CER_YEAR not between", value1, value2,
					"propertyCerYear");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceIsNull() {
			addCriterion("HOUSE_LOAN_BALANCE is null");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceIsNotNull() {
			addCriterion("HOUSE_LOAN_BALANCE is not null");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceEqualTo(Float value) {
			addCriterion("HOUSE_LOAN_BALANCE =", value, "houseLoanBalance");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceNotEqualTo(Float value) {
			addCriterion("HOUSE_LOAN_BALANCE <>", value, "houseLoanBalance");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceGreaterThan(Float value) {
			addCriterion("HOUSE_LOAN_BALANCE >", value, "houseLoanBalance");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceGreaterThanOrEqualTo(Float value) {
			addCriterion("HOUSE_LOAN_BALANCE >=", value, "houseLoanBalance");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceLessThan(Float value) {
			addCriterion("HOUSE_LOAN_BALANCE <", value, "houseLoanBalance");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceLessThanOrEqualTo(Float value) {
			addCriterion("HOUSE_LOAN_BALANCE <=", value, "houseLoanBalance");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceIn(List<Float> values) {
			addCriterion("HOUSE_LOAN_BALANCE in", values, "houseLoanBalance");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceNotIn(List<Float> values) {
			addCriterion("HOUSE_LOAN_BALANCE not in", values,
					"houseLoanBalance");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceBetween(Float value1, Float value2) {
			addCriterion("HOUSE_LOAN_BALANCE between", value1, value2,
					"houseLoanBalance");
			return (Criteria) this;
		}

		public Criteria andHouseLoanBalanceNotBetween(Float value1, Float value2) {
			addCriterion("HOUSE_LOAN_BALANCE not between", value1, value2,
					"houseLoanBalance");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameIsNull() {
			addCriterion("PROPERTY_OWNER_NAME is null");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameIsNotNull() {
			addCriterion("PROPERTY_OWNER_NAME is not null");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameEqualTo(String value) {
			addCriterion("PROPERTY_OWNER_NAME =", value, "propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameNotEqualTo(String value) {
			addCriterion("PROPERTY_OWNER_NAME <>", value, "propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameGreaterThan(String value) {
			addCriterion("PROPERTY_OWNER_NAME >", value, "propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameGreaterThanOrEqualTo(String value) {
			addCriterion("PROPERTY_OWNER_NAME >=", value, "propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameLessThan(String value) {
			addCriterion("PROPERTY_OWNER_NAME <", value, "propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameLessThanOrEqualTo(String value) {
			addCriterion("PROPERTY_OWNER_NAME <=", value, "propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameLike(String value) {
			addCriterion("PROPERTY_OWNER_NAME like", value, "propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameNotLike(String value) {
			addCriterion("PROPERTY_OWNER_NAME not like", value,
					"propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameIn(List<String> values) {
			addCriterion("PROPERTY_OWNER_NAME in", values, "propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameNotIn(List<String> values) {
			addCriterion("PROPERTY_OWNER_NAME not in", values,
					"propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameBetween(String value1, String value2) {
			addCriterion("PROPERTY_OWNER_NAME between", value1, value2,
					"propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerNameNotBetween(String value1,
				String value2) {
			addCriterion("PROPERTY_OWNER_NAME not between", value1, value2,
					"propertyOwnerName");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortIsNull() {
			addCriterion("PROPERTY_OWNER_SHORT is null");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortIsNotNull() {
			addCriterion("PROPERTY_OWNER_SHORT is not null");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortEqualTo(String value) {
			addCriterion("PROPERTY_OWNER_SHORT =", value, "propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortNotEqualTo(String value) {
			addCriterion("PROPERTY_OWNER_SHORT <>", value, "propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortGreaterThan(String value) {
			addCriterion("PROPERTY_OWNER_SHORT >", value, "propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortGreaterThanOrEqualTo(String value) {
			addCriterion("PROPERTY_OWNER_SHORT >=", value, "propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortLessThan(String value) {
			addCriterion("PROPERTY_OWNER_SHORT <", value, "propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortLessThanOrEqualTo(String value) {
			addCriterion("PROPERTY_OWNER_SHORT <=", value, "propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortLike(String value) {
			addCriterion("PROPERTY_OWNER_SHORT like", value,
					"propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortNotLike(String value) {
			addCriterion("PROPERTY_OWNER_SHORT not like", value,
					"propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortIn(List<String> values) {
			addCriterion("PROPERTY_OWNER_SHORT in", values,
					"propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortNotIn(List<String> values) {
			addCriterion("PROPERTY_OWNER_SHORT not in", values,
					"propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortBetween(String value1,
				String value2) {
			addCriterion("PROPERTY_OWNER_SHORT between", value1, value2,
					"propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andPropertyOwnerShortNotBetween(String value1,
				String value2) {
			addCriterion("PROPERTY_OWNER_SHORT not between", value1, value2,
					"propertyOwnerShort");
			return (Criteria) this;
		}

		public Criteria andNativePlaceIsNull() {
			addCriterion("NATIVE_PLACE is null");
			return (Criteria) this;
		}

		public Criteria andNativePlaceIsNotNull() {
			addCriterion("NATIVE_PLACE is not null");
			return (Criteria) this;
		}

		public Criteria andNativePlaceEqualTo(String value) {
			addCriterion("NATIVE_PLACE =", value, "nativePlace");
			return (Criteria) this;
		}

		public Criteria andNativePlaceNotEqualTo(String value) {
			addCriterion("NATIVE_PLACE <>", value, "nativePlace");
			return (Criteria) this;
		}

		public Criteria andNativePlaceGreaterThan(String value) {
			addCriterion("NATIVE_PLACE >", value, "nativePlace");
			return (Criteria) this;
		}

		public Criteria andNativePlaceGreaterThanOrEqualTo(String value) {
			addCriterion("NATIVE_PLACE >=", value, "nativePlace");
			return (Criteria) this;
		}

		public Criteria andNativePlaceLessThan(String value) {
			addCriterion("NATIVE_PLACE <", value, "nativePlace");
			return (Criteria) this;
		}

		public Criteria andNativePlaceLessThanOrEqualTo(String value) {
			addCriterion("NATIVE_PLACE <=", value, "nativePlace");
			return (Criteria) this;
		}

		public Criteria andNativePlaceLike(String value) {
			addCriterion("NATIVE_PLACE like", value, "nativePlace");
			return (Criteria) this;
		}

		public Criteria andNativePlaceNotLike(String value) {
			addCriterion("NATIVE_PLACE not like", value, "nativePlace");
			return (Criteria) this;
		}

		public Criteria andNativePlaceIn(List<String> values) {
			addCriterion("NATIVE_PLACE in", values, "nativePlace");
			return (Criteria) this;
		}

		public Criteria andNativePlaceNotIn(List<String> values) {
			addCriterion("NATIVE_PLACE not in", values, "nativePlace");
			return (Criteria) this;
		}

		public Criteria andNativePlaceBetween(String value1, String value2) {
			addCriterion("NATIVE_PLACE between", value1, value2, "nativePlace");
			return (Criteria) this;
		}

		public Criteria andNativePlaceNotBetween(String value1, String value2) {
			addCriterion("NATIVE_PLACE not between", value1, value2,
					"nativePlace");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoIsNull() {
			addCriterion("OWNER_CER_NO is null");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoIsNotNull() {
			addCriterion("OWNER_CER_NO is not null");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoEqualTo(String value) {
			addCriterion("OWNER_CER_NO =", value, "ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoNotEqualTo(String value) {
			addCriterion("OWNER_CER_NO <>", value, "ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoGreaterThan(String value) {
			addCriterion("OWNER_CER_NO >", value, "ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoGreaterThanOrEqualTo(String value) {
			addCriterion("OWNER_CER_NO >=", value, "ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoLessThan(String value) {
			addCriterion("OWNER_CER_NO <", value, "ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoLessThanOrEqualTo(String value) {
			addCriterion("OWNER_CER_NO <=", value, "ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoLike(String value) {
			addCriterion("OWNER_CER_NO like", value, "ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoNotLike(String value) {
			addCriterion("OWNER_CER_NO not like", value, "ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoIn(List<String> values) {
			addCriterion("OWNER_CER_NO in", values, "ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoNotIn(List<String> values) {
			addCriterion("OWNER_CER_NO not in", values, "ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoBetween(String value1, String value2) {
			addCriterion("OWNER_CER_NO between", value1, value2, "ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerCerNoNotBetween(String value1, String value2) {
			addCriterion("OWNER_CER_NO not between", value1, value2,
					"ownerCerNo");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumIsNull() {
			addCriterion("OWNER_LINK_PHONE_NUM is null");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumIsNotNull() {
			addCriterion("OWNER_LINK_PHONE_NUM is not null");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumEqualTo(String value) {
			addCriterion("OWNER_LINK_PHONE_NUM =", value, "ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumNotEqualTo(String value) {
			addCriterion("OWNER_LINK_PHONE_NUM <>", value, "ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumGreaterThan(String value) {
			addCriterion("OWNER_LINK_PHONE_NUM >", value, "ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumGreaterThanOrEqualTo(String value) {
			addCriterion("OWNER_LINK_PHONE_NUM >=", value, "ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumLessThan(String value) {
			addCriterion("OWNER_LINK_PHONE_NUM <", value, "ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumLessThanOrEqualTo(String value) {
			addCriterion("OWNER_LINK_PHONE_NUM <=", value, "ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumLike(String value) {
			addCriterion("OWNER_LINK_PHONE_NUM like", value,
					"ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumNotLike(String value) {
			addCriterion("OWNER_LINK_PHONE_NUM not like", value,
					"ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumIn(List<String> values) {
			addCriterion("OWNER_LINK_PHONE_NUM in", values, "ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumNotIn(List<String> values) {
			addCriterion("OWNER_LINK_PHONE_NUM not in", values,
					"ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumBetween(String value1, String value2) {
			addCriterion("OWNER_LINK_PHONE_NUM between", value1, value2,
					"ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerLinkPhoneNumNotBetween(String value1,
				String value2) {
			addCriterion("OWNER_LINK_PHONE_NUM not between", value1, value2,
					"ownerLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andOwnerQqIsNull() {
			addCriterion("OWNER_QQ is null");
			return (Criteria) this;
		}

		public Criteria andOwnerQqIsNotNull() {
			addCriterion("OWNER_QQ is not null");
			return (Criteria) this;
		}

		public Criteria andOwnerQqEqualTo(String value) {
			addCriterion("OWNER_QQ =", value, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerQqNotEqualTo(String value) {
			addCriterion("OWNER_QQ <>", value, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerQqGreaterThan(String value) {
			addCriterion("OWNER_QQ >", value, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerQqGreaterThanOrEqualTo(String value) {
			addCriterion("OWNER_QQ >=", value, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerQqLessThan(String value) {
			addCriterion("OWNER_QQ <", value, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerQqLessThanOrEqualTo(String value) {
			addCriterion("OWNER_QQ <=", value, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerQqLike(String value) {
			addCriterion("OWNER_QQ like", value, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerQqNotLike(String value) {
			addCriterion("OWNER_QQ not like", value, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerQqIn(List<String> values) {
			addCriterion("OWNER_QQ in", values, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerQqNotIn(List<String> values) {
			addCriterion("OWNER_QQ not in", values, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerQqBetween(String value1, String value2) {
			addCriterion("OWNER_QQ between", value1, value2, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerQqNotBetween(String value1, String value2) {
			addCriterion("OWNER_QQ not between", value1, value2, "ownerQq");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxIsNull() {
			addCriterion("OWNER_FAX is null");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxIsNotNull() {
			addCriterion("OWNER_FAX is not null");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxEqualTo(String value) {
			addCriterion("OWNER_FAX =", value, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxNotEqualTo(String value) {
			addCriterion("OWNER_FAX <>", value, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxGreaterThan(String value) {
			addCriterion("OWNER_FAX >", value, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxGreaterThanOrEqualTo(String value) {
			addCriterion("OWNER_FAX >=", value, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxLessThan(String value) {
			addCriterion("OWNER_FAX <", value, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxLessThanOrEqualTo(String value) {
			addCriterion("OWNER_FAX <=", value, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxLike(String value) {
			addCriterion("OWNER_FAX like", value, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxNotLike(String value) {
			addCriterion("OWNER_FAX not like", value, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxIn(List<String> values) {
			addCriterion("OWNER_FAX in", values, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxNotIn(List<String> values) {
			addCriterion("OWNER_FAX not in", values, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxBetween(String value1, String value2) {
			addCriterion("OWNER_FAX between", value1, value2, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerFaxNotBetween(String value1, String value2) {
			addCriterion("OWNER_FAX not between", value1, value2, "ownerFax");
			return (Criteria) this;
		}

		public Criteria andOwnerMailIsNull() {
			addCriterion("OWNER_MAIL is null");
			return (Criteria) this;
		}

		public Criteria andOwnerMailIsNotNull() {
			addCriterion("OWNER_MAIL is not null");
			return (Criteria) this;
		}

		public Criteria andOwnerMailEqualTo(String value) {
			addCriterion("OWNER_MAIL =", value, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerMailNotEqualTo(String value) {
			addCriterion("OWNER_MAIL <>", value, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerMailGreaterThan(String value) {
			addCriterion("OWNER_MAIL >", value, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerMailGreaterThanOrEqualTo(String value) {
			addCriterion("OWNER_MAIL >=", value, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerMailLessThan(String value) {
			addCriterion("OWNER_MAIL <", value, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerMailLessThanOrEqualTo(String value) {
			addCriterion("OWNER_MAIL <=", value, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerMailLike(String value) {
			addCriterion("OWNER_MAIL like", value, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerMailNotLike(String value) {
			addCriterion("OWNER_MAIL not like", value, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerMailIn(List<String> values) {
			addCriterion("OWNER_MAIL in", values, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerMailNotIn(List<String> values) {
			addCriterion("OWNER_MAIL not in", values, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerMailBetween(String value1, String value2) {
			addCriterion("OWNER_MAIL between", value1, value2, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerMailNotBetween(String value1, String value2) {
			addCriterion("OWNER_MAIL not between", value1, value2, "ownerMail");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthIsNull() {
			addCriterion("OWNER_BIRTH is null");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthIsNotNull() {
			addCriterion("OWNER_BIRTH is not null");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthEqualTo(String value) {
			addCriterion("OWNER_BIRTH =", value, "ownerBirth");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthNotEqualTo(String value) {
			addCriterion("OWNER_BIRTH <>", value, "ownerBirth");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthGreaterThan(String value) {
			addCriterion("OWNER_BIRTH >", value, "ownerBirth");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthGreaterThanOrEqualTo(String value) {
			addCriterion("OWNER_BIRTH >=", value, "ownerBirth");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthLessThan(String value) {
			addCriterion("OWNER_BIRTH <", value, "ownerBirth");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthLessThanOrEqualTo(String value) {
			addCriterion("OWNER_BIRTH <=", value, "ownerBirth");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthLike(String value) {
			addCriterion("OWNER_BIRTH like", value, "ownerBirth");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthNotLike(String value) {
			addCriterion("OWNER_BIRTH not like", value, "ownerBirth");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthIn(List<String> values) {
			addCriterion("OWNER_BIRTH in", values, "ownerBirth");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthNotIn(List<String> values) {
			addCriterion("OWNER_BIRTH not in", values, "ownerBirth");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthBetween(String value1, String value2) {
			addCriterion("OWNER_BIRTH between", value1, value2, "ownerBirth");
			return (Criteria) this;
		}

		public Criteria andOwnerBirthNotBetween(String value1, String value2) {
			addCriterion("OWNER_BIRTH not between", value1, value2,
					"ownerBirth");
			return (Criteria) this;
		}

		public Criteria andRemarkIsNull() {
			addCriterion("REMARK is null");
			return (Criteria) this;
		}

		public Criteria andRemarkIsNotNull() {
			addCriterion("REMARK is not null");
			return (Criteria) this;
		}

		public Criteria andRemarkEqualTo(String value) {
			addCriterion("REMARK =", value, "remark");
			return (Criteria) this;
		}

		public Criteria andRemarkNotEqualTo(String value) {
			addCriterion("REMARK <>", value, "remark");
			return (Criteria) this;
		}

		public Criteria andRemarkGreaterThan(String value) {
			addCriterion("REMARK >", value, "remark");
			return (Criteria) this;
		}

		public Criteria andRemarkGreaterThanOrEqualTo(String value) {
			addCriterion("REMARK >=", value, "remark");
			return (Criteria) this;
		}

		public Criteria andRemarkLessThan(String value) {
			addCriterion("REMARK <", value, "remark");
			return (Criteria) this;
		}

		public Criteria andRemarkLessThanOrEqualTo(String value) {
			addCriterion("REMARK <=", value, "remark");
			return (Criteria) this;
		}

		public Criteria andRemarkLike(String value) {
			addCriterion("REMARK like", value, "remark");
			return (Criteria) this;
		}

		public Criteria andRemarkNotLike(String value) {
			addCriterion("REMARK not like", value, "remark");
			return (Criteria) this;
		}

		public Criteria andRemarkIn(List<String> values) {
			addCriterion("REMARK in", values, "remark");
			return (Criteria) this;
		}

		public Criteria andRemarkNotIn(List<String> values) {
			addCriterion("REMARK not in", values, "remark");
			return (Criteria) this;
		}

		public Criteria andRemarkBetween(String value1, String value2) {
			addCriterion("REMARK between", value1, value2, "remark");
			return (Criteria) this;
		}

		public Criteria andRemarkNotBetween(String value1, String value2) {
			addCriterion("REMARK not between", value1, value2, "remark");
			return (Criteria) this;
		}

		public Criteria andAgentNameIsNull() {
			addCriterion("AGENT_NAME is null");
			return (Criteria) this;
		}

		public Criteria andAgentNameIsNotNull() {
			addCriterion("AGENT_NAME is not null");
			return (Criteria) this;
		}

		public Criteria andAgentNameEqualTo(String value) {
			addCriterion("AGENT_NAME =", value, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentNameNotEqualTo(String value) {
			addCriterion("AGENT_NAME <>", value, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentNameGreaterThan(String value) {
			addCriterion("AGENT_NAME >", value, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentNameGreaterThanOrEqualTo(String value) {
			addCriterion("AGENT_NAME >=", value, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentNameLessThan(String value) {
			addCriterion("AGENT_NAME <", value, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentNameLessThanOrEqualTo(String value) {
			addCriterion("AGENT_NAME <=", value, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentNameLike(String value) {
			addCriterion("AGENT_NAME like", value, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentNameNotLike(String value) {
			addCriterion("AGENT_NAME not like", value, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentNameIn(List<String> values) {
			addCriterion("AGENT_NAME in", values, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentNameNotIn(List<String> values) {
			addCriterion("AGENT_NAME not in", values, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentNameBetween(String value1, String value2) {
			addCriterion("AGENT_NAME between", value1, value2, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentNameNotBetween(String value1, String value2) {
			addCriterion("AGENT_NAME not between", value1, value2, "agentName");
			return (Criteria) this;
		}

		public Criteria andAgentShortIsNull() {
			addCriterion("AGENT_SHORT is null");
			return (Criteria) this;
		}

		public Criteria andAgentShortIsNotNull() {
			addCriterion("AGENT_SHORT is not null");
			return (Criteria) this;
		}

		public Criteria andAgentShortEqualTo(String value) {
			addCriterion("AGENT_SHORT =", value, "agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentShortNotEqualTo(String value) {
			addCriterion("AGENT_SHORT <>", value, "agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentShortGreaterThan(String value) {
			addCriterion("AGENT_SHORT >", value, "agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentShortGreaterThanOrEqualTo(String value) {
			addCriterion("AGENT_SHORT >=", value, "agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentShortLessThan(String value) {
			addCriterion("AGENT_SHORT <", value, "agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentShortLessThanOrEqualTo(String value) {
			addCriterion("AGENT_SHORT <=", value, "agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentShortLike(String value) {
			addCriterion("AGENT_SHORT like", value, "agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentShortNotLike(String value) {
			addCriterion("AGENT_SHORT not like", value, "agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentShortIn(List<String> values) {
			addCriterion("AGENT_SHORT in", values, "agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentShortNotIn(List<String> values) {
			addCriterion("AGENT_SHORT not in", values, "agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentShortBetween(String value1, String value2) {
			addCriterion("AGENT_SHORT between", value1, value2, "agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentShortNotBetween(String value1, String value2) {
			addCriterion("AGENT_SHORT not between", value1, value2,
					"agentShort");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceIsNull() {
			addCriterion("AGENT_NATIVE_PLACE is null");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceIsNotNull() {
			addCriterion("AGENT_NATIVE_PLACE is not null");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceEqualTo(String value) {
			addCriterion("AGENT_NATIVE_PLACE =", value, "agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceNotEqualTo(String value) {
			addCriterion("AGENT_NATIVE_PLACE <>", value, "agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceGreaterThan(String value) {
			addCriterion("AGENT_NATIVE_PLACE >", value, "agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceGreaterThanOrEqualTo(String value) {
			addCriterion("AGENT_NATIVE_PLACE >=", value, "agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceLessThan(String value) {
			addCriterion("AGENT_NATIVE_PLACE <", value, "agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceLessThanOrEqualTo(String value) {
			addCriterion("AGENT_NATIVE_PLACE <=", value, "agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceLike(String value) {
			addCriterion("AGENT_NATIVE_PLACE like", value, "agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceNotLike(String value) {
			addCriterion("AGENT_NATIVE_PLACE not like", value,
					"agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceIn(List<String> values) {
			addCriterion("AGENT_NATIVE_PLACE in", values, "agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceNotIn(List<String> values) {
			addCriterion("AGENT_NATIVE_PLACE not in", values,
					"agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceBetween(String value1, String value2) {
			addCriterion("AGENT_NATIVE_PLACE between", value1, value2,
					"agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentNativePlaceNotBetween(String value1,
				String value2) {
			addCriterion("AGENT_NATIVE_PLACE not between", value1, value2,
					"agentNativePlace");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoIsNull() {
			addCriterion("AGENT_CER_NO is null");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoIsNotNull() {
			addCriterion("AGENT_CER_NO is not null");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoEqualTo(String value) {
			addCriterion("AGENT_CER_NO =", value, "agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoNotEqualTo(String value) {
			addCriterion("AGENT_CER_NO <>", value, "agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoGreaterThan(String value) {
			addCriterion("AGENT_CER_NO >", value, "agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoGreaterThanOrEqualTo(String value) {
			addCriterion("AGENT_CER_NO >=", value, "agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoLessThan(String value) {
			addCriterion("AGENT_CER_NO <", value, "agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoLessThanOrEqualTo(String value) {
			addCriterion("AGENT_CER_NO <=", value, "agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoLike(String value) {
			addCriterion("AGENT_CER_NO like", value, "agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoNotLike(String value) {
			addCriterion("AGENT_CER_NO not like", value, "agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoIn(List<String> values) {
			addCriterion("AGENT_CER_NO in", values, "agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoNotIn(List<String> values) {
			addCriterion("AGENT_CER_NO not in", values, "agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoBetween(String value1, String value2) {
			addCriterion("AGENT_CER_NO between", value1, value2, "agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentCerNoNotBetween(String value1, String value2) {
			addCriterion("AGENT_CER_NO not between", value1, value2,
					"agentCerNo");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumIsNull() {
			addCriterion("AGENT_LINK_PHONE_NUM is null");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumIsNotNull() {
			addCriterion("AGENT_LINK_PHONE_NUM is not null");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumEqualTo(String value) {
			addCriterion("AGENT_LINK_PHONE_NUM =", value, "agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumNotEqualTo(String value) {
			addCriterion("AGENT_LINK_PHONE_NUM <>", value, "agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumGreaterThan(String value) {
			addCriterion("AGENT_LINK_PHONE_NUM >", value, "agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumGreaterThanOrEqualTo(String value) {
			addCriterion("AGENT_LINK_PHONE_NUM >=", value, "agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumLessThan(String value) {
			addCriterion("AGENT_LINK_PHONE_NUM <", value, "agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumLessThanOrEqualTo(String value) {
			addCriterion("AGENT_LINK_PHONE_NUM <=", value, "agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumLike(String value) {
			addCriterion("AGENT_LINK_PHONE_NUM like", value,
					"agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumNotLike(String value) {
			addCriterion("AGENT_LINK_PHONE_NUM not like", value,
					"agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumIn(List<String> values) {
			addCriterion("AGENT_LINK_PHONE_NUM in", values, "agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumNotIn(List<String> values) {
			addCriterion("AGENT_LINK_PHONE_NUM not in", values,
					"agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumBetween(String value1, String value2) {
			addCriterion("AGENT_LINK_PHONE_NUM between", value1, value2,
					"agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andAgentLinkPhoneNumNotBetween(String value1,
				String value2) {
			addCriterion("AGENT_LINK_PHONE_NUM not between", value1, value2,
					"agentLinkPhoneNum");
			return (Criteria) this;
		}

		public Criteria andUserIdIsNull() {
			addCriterion("USER_ID is null");
			return (Criteria) this;
		}

		public Criteria andUserIdIsNotNull() {
			addCriterion("USER_ID is not null");
			return (Criteria) this;
		}

		public Criteria andUserIdEqualTo(String value) {
			addCriterion("USER_ID =", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdNotEqualTo(String value) {
			addCriterion("USER_ID <>", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdGreaterThan(String value) {
			addCriterion("USER_ID >", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdGreaterThanOrEqualTo(String value) {
			addCriterion("USER_ID >=", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdLessThan(String value) {
			addCriterion("USER_ID <", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdLessThanOrEqualTo(String value) {
			addCriterion("USER_ID <=", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdLike(String value) {
			addCriterion("USER_ID like", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdNotLike(String value) {
			addCriterion("USER_ID not like", value, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdIn(List<String> values) {
			addCriterion("USER_ID in", values, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdNotIn(List<String> values) {
			addCriterion("USER_ID not in", values, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdBetween(String value1, String value2) {
			addCriterion("USER_ID between", value1, value2, "userId");
			return (Criteria) this;
		}

		public Criteria andUserIdNotBetween(String value1, String value2) {
			addCriterion("USER_ID not between", value1, value2, "userId");
			return (Criteria) this;
		}

		public Criteria andCreateTimeIsNull() {
			addCriterion("CREATE_TIME is null");
			return (Criteria) this;
		}

		public Criteria andCreateTimeIsNotNull() {
			addCriterion("CREATE_TIME is not null");
			return (Criteria) this;
		}

		public Criteria andCreateTimeEqualTo(Date value) {
			addCriterion("CREATE_TIME =", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeNotEqualTo(Date value) {
			addCriterion("CREATE_TIME <>", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeGreaterThan(Date value) {
			addCriterion("CREATE_TIME >", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
			addCriterion("CREATE_TIME >=", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeLessThan(Date value) {
			addCriterion("CREATE_TIME <", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
			addCriterion("CREATE_TIME <=", value, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeIn(List<Date> values) {
			addCriterion("CREATE_TIME in", values, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeNotIn(List<Date> values) {
			addCriterion("CREATE_TIME not in", values, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeBetween(Date value1, Date value2) {
			addCriterion("CREATE_TIME between", value1, value2, "createTime");
			return (Criteria) this;
		}

		public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
			addCriterion("CREATE_TIME not between", value1, value2,
					"createTime");
			return (Criteria) this;
		}

		public Criteria andModTimeIsNull() {
			addCriterion("MOD_TIME is null");
			return (Criteria) this;
		}

		public Criteria andModTimeIsNotNull() {
			addCriterion("MOD_TIME is not null");
			return (Criteria) this;
		}

		public Criteria andModTimeEqualTo(Date value) {
			addCriterion("MOD_TIME =", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeNotEqualTo(Date value) {
			addCriterion("MOD_TIME <>", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeGreaterThan(Date value) {
			addCriterion("MOD_TIME >", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeGreaterThanOrEqualTo(Date value) {
			addCriterion("MOD_TIME >=", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeLessThan(Date value) {
			addCriterion("MOD_TIME <", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeLessThanOrEqualTo(Date value) {
			addCriterion("MOD_TIME <=", value, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeIn(List<Date> values) {
			addCriterion("MOD_TIME in", values, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeNotIn(List<Date> values) {
			addCriterion("MOD_TIME not in", values, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeBetween(Date value1, Date value2) {
			addCriterion("MOD_TIME between", value1, value2, "modTime");
			return (Criteria) this;
		}

		public Criteria andModTimeNotBetween(Date value1, Date value2) {
			addCriterion("MOD_TIME not between", value1, value2, "modTime");
			return (Criteria) this;
		}

		public Criteria andDelFlagIsNull() {
			addCriterion("DEL_FLAG is null");
			return (Criteria) this;
		}

		public Criteria andDelFlagIsNotNull() {
			addCriterion("DEL_FLAG is not null");
			return (Criteria) this;
		}

		public Criteria andDelFlagEqualTo(Integer value) {
			addCriterion("DEL_FLAG =", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagNotEqualTo(Integer value) {
			addCriterion("DEL_FLAG <>", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagGreaterThan(Integer value) {
			addCriterion("DEL_FLAG >", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagGreaterThanOrEqualTo(Integer value) {
			addCriterion("DEL_FLAG >=", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagLessThan(Integer value) {
			addCriterion("DEL_FLAG <", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagLessThanOrEqualTo(Integer value) {
			addCriterion("DEL_FLAG <=", value, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagIn(List<Integer> values) {
			addCriterion("DEL_FLAG in", values, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagNotIn(List<Integer> values) {
			addCriterion("DEL_FLAG not in", values, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagBetween(Integer value1, Integer value2) {
			addCriterion("DEL_FLAG between", value1, value2, "delFlag");
			return (Criteria) this;
		}

		public Criteria andDelFlagNotBetween(Integer value1, Integer value2) {
			addCriterion("DEL_FLAG not between", value1, value2, "delFlag");
			return (Criteria) this;
		}
	}

	/**
	 * This class was generated by MyBatis Generator. This class corresponds to the database table house_property_info
	 * @mbggenerated
	 */
	public static class Criterion {
		private String condition;
		private Object value;
		private Object secondValue;
		private boolean noValue;
		private boolean singleValue;
		private boolean betweenValue;
		private boolean listValue;
		private String typeHandler;

		public String getCondition() {
			return condition;
		}

		public Object getValue() {
			return value;
		}

		public Object getSecondValue() {
			return secondValue;
		}

		public boolean isNoValue() {
			return noValue;
		}

		public boolean isSingleValue() {
			return singleValue;
		}

		public boolean isBetweenValue() {
			return betweenValue;
		}

		public boolean isListValue() {
			return listValue;
		}

		public String getTypeHandler() {
			return typeHandler;
		}

		protected Criterion(String condition) {
			super();
			this.condition = condition;
			this.typeHandler = null;
			this.noValue = true;
		}

		protected Criterion(String condition, Object value, String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.typeHandler = typeHandler;
			if (value instanceof List<?>) {
				this.listValue = true;
			} else {
				this.singleValue = true;
			}
		}

		protected Criterion(String condition, Object value) {
			this(condition, value, null);
		}

		protected Criterion(String condition, Object value, Object secondValue,
				String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.secondValue = secondValue;
			this.typeHandler = typeHandler;
			this.betweenValue = true;
		}

		protected Criterion(String condition, Object value, Object secondValue) {
			this(condition, value, secondValue, null);
		}
	}

	/**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table house_property_info
     *
     * @mbggenerated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }
}